<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="WeddingDB" targetNamespace="http://tempuri.org/WeddingDB.xsd" xmlns:mstns="http://tempuri.org/WeddingDB.xsd" xmlns="http://tempuri.org/WeddingDB.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="cherylWeddingConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="cherylWeddingConnectionString (Web.config)" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.cherylWeddingConnectionString.ConnectionString" Provider="System.Data.OleDb">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MessagesTableAdapter" GeneratorDataComponentClassName="MessagesTableAdapter" Name="Messages" UserDataComponentName="MessagesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cherylWeddingConnectionString (Web.config)" DbObjectName="Messages" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetAllMessages" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetAllMessages" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllMessages" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `Messages` WHERE ((`MessageId` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_MessageId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="MessageId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `Messages` (`Name`, `Message`, `DatePosted`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Message" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Message" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="DatePosted" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DatePosted" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     MessageId, Name, Message, DatePosted
FROM         Messages
ORDER BY DatePosted DESC</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `Messages` SET `Name` = ?, `Message` = ?, `DatePosted` = ? WHERE ((`MessageId` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Message" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Message" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="DatePosted" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DatePosted" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_MessageId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="MessageId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MessageId" DataSetColumn="MessageId" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Message" DataSetColumn="Message" />
              <Mapping SourceColumn="DatePosted" DataSetColumn="DatePosted" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RSVPTableAdapter" GeneratorDataComponentClassName="RSVPTableAdapter" Name="RSVP" UserDataComponentName="RSVPTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cherylWeddingConnectionString (Web.config)" DbObjectName="RSVP" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetAllReservations" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetAllReservations" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllReservations" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `RSVP` WHERE ((`ReservationId` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ReservationId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReservationId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `RSVP` (`ReservationNo`, `Name`, `NumberAttending`, `DatePosted`) VALUES (?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ReservationNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReservationNo" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="NumberAttending" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="NumberAttending" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="DatePosted" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DatePosted" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT ReservationId, ReservationNo, Name, NumberAttending, DatePosted FROM RSVP
order by datePosted</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `RSVP` SET `ReservationNo` = ?, `Name` = ?, `NumberAttending` = ?, `DatePosted` = ? WHERE ((`ReservationId` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ReservationNo" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReservationNo" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="NumberAttending" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="NumberAttending" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="DatePosted" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DatePosted" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ReservationId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ReservationId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ReservationId" DataSetColumn="ReservationId" />
              <Mapping SourceColumn="ReservationNo" DataSetColumn="ReservationNo" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="NumberAttending" DataSetColumn="NumberAttending" />
              <Mapping SourceColumn="DatePosted" DataSetColumn="DatePosted" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="cherylWeddingConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="GetMaxReservationNo" Modifier="Public" Name="GetMaxReservationNo" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="GetMaxReservationNo">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT max(reservationNo) FROM RSVP</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="cherylWeddingConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="GetTotalAttending" Modifier="Public" Name="GetTotalAttending" QueryType="Scalar" ScalarCallRetval="System.Double, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="GetTotalAttending">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     SUM(NumberAttending) AS TotalAttending
FROM         RSVP</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cherylWeddingConnectionString (Web.config)" DbObjectName="Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetAllUsers" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetAllUsers" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAllUsers" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `Users` WHERE ((`UserId` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `Users` (`UserName`, `Password`, `LastLoginDate`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UserName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Password" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="LastLoginDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastLoginDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     UserId, UserName, [Password], LastLoginDate
FROM         Users
ORDER BY UserName</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `Users` SET `UserName` = ?, `Password` = ?, `LastLoginDate` = ? WHERE ((`UserId` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="UserName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Password" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Password" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="LastLoginDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastLoginDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_UserId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserId" DataSetColumn="UserId" />
              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
              <Mapping SourceColumn="Password" DataSetColumn="Password" />
              <Mapping SourceColumn="LastLoginDate" DataSetColumn="LastLoginDate" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="cherylWeddingConnectionString (Web.config)" DbObjectName="Users" DbObjectType="Table" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="GetUserId" Modifier="Public" Name="GetUserId" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="GetUserId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     UserId
FROM         Users
WHERE     (UserName = ?) AND ([Password] = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="UserName" DataSourceName="Users" DataTypeServer="DbType.StringFixedLength(50)" DbType="String" Direction="Input" ParameterName="UserName" Precision="0" ProviderType="WChar" Scale="0" Size="50" SourceColumn="UserName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param2" ColumnName="Password" DataSourceName="Users" DataTypeServer="DbType.StringFixedLength(32)" DbType="String" Direction="Input" ParameterName="Password" Precision="0" ProviderType="WChar" Scale="0" Size="32" SourceColumn="Password" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="cherylWeddingConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="UpdateLastLogin" Modifier="Public" Name="UpdateLastLogin" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="UpdateLastLogin">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>UPDATE    Users
SET              LastLoginDate = ?
WHERE     (UserId = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="LastLoginDate" DataSourceName="Users" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="LastLoginDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastLoginDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param2" ColumnName="UserId" DataSourceName="Users" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="UserId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="HitsTableAdapter" GeneratorDataComponentClassName="HitsTableAdapter" Name="Hits" UserDataComponentName="HitsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cherylWeddingConnectionString (Web.config)" DbObjectName="Hits" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetHits" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetHits" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetHits" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `Hits` WHERE ((`HitId` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_HitId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="HitId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO `Hits` (`IPAddress`, `Identity`, `Timestamp`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IPAddress" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="IPAddress" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Identity" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Identity" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Timestamp" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     HitId, IPAddress, [Identity], [Timestamp]
FROM         Hits
ORDER BY [Timestamp]</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `Hits` SET `IPAddress` = ?, `Identity` = ?, `Timestamp` = ? WHERE ((`HitId` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="IPAddress" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="IPAddress" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Identity" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Identity" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Timestamp" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_HitId" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="HitId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="HitId" DataSetColumn="HitId" />
              <Mapping SourceColumn="IPAddress" DataSetColumn="IPAddress" />
              <Mapping SourceColumn="Identity" DataSetColumn="Identity" />
              <Mapping SourceColumn="Timestamp" DataSetColumn="Timestamp" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="cherylWeddingConnectionString (Web.config)" DbObjectName="Hits" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetHitsByDate" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetHitsByDate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetHitsByDate" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     HitId, IPAddress, [Identity], [Timestamp]
FROM         Hits
WHERE     ([Timestamp] BETWEEN ? AND ?)
ORDER BY [Timestamp]</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param1" ColumnName="Timestamp" DataSourceName="Hits" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="BeginDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param2" ColumnName="Timestamp" DataSourceName="Hits" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="EndDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="cherylWeddingConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorSourceName="GetTotalHits" Modifier="Public" Name="GetTotalHits" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="GetTotalHits">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT COUNT(*) FROM Hits</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="WeddingDB" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="WeddingDB" msprop:Generator_DataSetName="WeddingDB">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Messages" msprop:Generator_UserTableName="Messages" msprop:Generator_RowDeletedName="MessagesRowDeleted" msprop:Generator_RowChangedName="MessagesRowChanged" msprop:Generator_RowClassName="MessagesRow" msprop:Generator_RowChangingName="MessagesRowChanging" msprop:Generator_RowEvArgName="MessagesRowChangeEvent" msprop:Generator_RowEvHandlerName="MessagesRowChangeEventHandler" msprop:Generator_TableClassName="MessagesDataTable" msprop:Generator_TableVarName="tableMessages" msprop:Generator_RowDeletingName="MessagesRowDeleting" msprop:Generator_TablePropName="Messages">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MessageId" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="MessageId" msprop:Generator_ColumnPropNameInRow="MessageId" msprop:Generator_ColumnVarNameInTable="columnMessageId" msprop:Generator_ColumnPropNameInTable="MessageIdColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Message" msprop:Generator_UserColumnName="Message" msprop:Generator_ColumnPropNameInRow="Message" msprop:Generator_ColumnVarNameInTable="columnMessage" msprop:Generator_ColumnPropNameInTable="MessageColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DatePosted" msprop:Generator_UserColumnName="DatePosted" msprop:Generator_ColumnPropNameInRow="DatePosted" msprop:Generator_ColumnVarNameInTable="columnDatePosted" msprop:Generator_ColumnPropNameInTable="DatePostedColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="RSVP" msprop:Generator_UserTableName="RSVP" msprop:Generator_RowDeletedName="RSVPRowDeleted" msprop:Generator_RowChangedName="RSVPRowChanged" msprop:Generator_RowClassName="RSVPRow" msprop:Generator_RowChangingName="RSVPRowChanging" msprop:Generator_RowEvArgName="RSVPRowChangeEvent" msprop:Generator_RowEvHandlerName="RSVPRowChangeEventHandler" msprop:Generator_TableClassName="RSVPDataTable" msprop:Generator_TableVarName="tableRSVP" msprop:Generator_RowDeletingName="RSVPRowDeleting" msprop:Generator_TablePropName="RSVP">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ReservationId" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ReservationId" msprop:Generator_ColumnPropNameInRow="ReservationId" msprop:Generator_ColumnVarNameInTable="columnReservationId" msprop:Generator_ColumnPropNameInTable="ReservationIdColumn" type="xs:int" />
              <xs:element name="ReservationNo" msprop:Generator_UserColumnName="ReservationNo" msprop:Generator_ColumnPropNameInRow="ReservationNo" msprop:Generator_ColumnVarNameInTable="columnReservationNo" msprop:Generator_ColumnPropNameInTable="ReservationNoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumberAttending" msprop:Generator_UserColumnName="NumberAttending" msprop:Generator_ColumnPropNameInRow="NumberAttending" msprop:Generator_ColumnVarNameInTable="columnNumberAttending" msprop:Generator_ColumnPropNameInTable="NumberAttendingColumn" type="xs:short" minOccurs="0" />
              <xs:element name="DatePosted" msprop:Generator_UserColumnName="DatePosted" msprop:Generator_ColumnPropNameInRow="DatePosted" msprop:Generator_ColumnVarNameInTable="columnDatePosted" msprop:Generator_ColumnPropNameInTable="DatePostedColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Users" msprop:Generator_UserTableName="Users" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowClassName="UsersRow" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_TableVarName="tableUsers" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_TablePropName="Users">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserId" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="UserId" msprop:Generator_ColumnPropNameInRow="UserId" msprop:Generator_ColumnVarNameInTable="columnUserId" msprop:Generator_ColumnPropNameInTable="UserIdColumn" type="xs:int" />
              <xs:element name="UserName" msprop:Generator_UserColumnName="UserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Password" msprop:Generator_UserColumnName="Password" msprop:Generator_ColumnPropNameInRow="Password" msprop:Generator_ColumnVarNameInTable="columnPassword" msprop:Generator_ColumnPropNameInTable="PasswordColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastLoginDate" msprop:Generator_UserColumnName="LastLoginDate" msprop:Generator_ColumnPropNameInRow="LastLoginDate" msprop:Generator_ColumnVarNameInTable="columnLastLoginDate" msprop:Generator_ColumnPropNameInTable="LastLoginDateColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Hits" msprop:Generator_UserTableName="Hits" msprop:Generator_RowDeletedName="HitsRowDeleted" msprop:Generator_RowChangedName="HitsRowChanged" msprop:Generator_RowClassName="HitsRow" msprop:Generator_RowChangingName="HitsRowChanging" msprop:Generator_RowEvArgName="HitsRowChangeEvent" msprop:Generator_RowEvHandlerName="HitsRowChangeEventHandler" msprop:Generator_TableClassName="HitsDataTable" msprop:Generator_TableVarName="tableHits" msprop:Generator_RowDeletingName="HitsRowDeleting" msprop:Generator_TablePropName="Hits">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="HitId" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="HitId" msprop:Generator_ColumnPropNameInRow="HitId" msprop:Generator_ColumnVarNameInTable="columnHitId" msprop:Generator_ColumnPropNameInTable="HitIdColumn" type="xs:int" />
              <xs:element name="IPAddress" msprop:Generator_UserColumnName="IPAddress" msprop:Generator_ColumnPropNameInRow="IPAddress" msprop:Generator_ColumnVarNameInTable="columnIPAddress" msprop:Generator_ColumnPropNameInTable="IPAddressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="16" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Identity" msprop:Generator_UserColumnName="Identity" msprop:Generator_ColumnPropNameInRow="Identity" msprop:Generator_ColumnVarNameInTable="columnIdentity" msprop:Generator_ColumnPropNameInTable="IdentityColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Timestamp" msprop:Generator_UserColumnName="Timestamp" msprop:Generator_ColumnPropNameInRow="Timestamp" msprop:Generator_ColumnVarNameInTable="columnTimestamp" msprop:Generator_ColumnPropNameInTable="TimestampColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Messages" />
      <xs:field xpath="mstns:MessageId" />
    </xs:unique>
    <xs:unique name="RSVP_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:RSVP" />
      <xs:field xpath="mstns:ReservationId" />
    </xs:unique>
    <xs:unique name="Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Users" />
      <xs:field xpath="mstns:UserId" />
    </xs:unique>
    <xs:unique name="Hits_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Hits" />
      <xs:field xpath="mstns:HitId" />
    </xs:unique>
  </xs:element>
</xs:schema>